package com.leaf.lowcode.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.leaf.lowcode.entity.DoorPersonCountDTO;
import org.apache.ibatis.annotations.Select;


public interface DoorevenPersonMapper extends BaseMapper<DoorPersonCountDTO> {

    @Select("select * from access_inout_person_count where event_id = #{eventId}")
    DoorPersonCountDTO selectId(String eventId);

    @Select("SELECT COUNT(*) FROM access_inout_person_count  WHERE  in_and_out_type=#{InAndOut} AND  event_time BETWEEN #{startStr} AND #{endStr}")
    int count(String InAndOut,String startStr,String endStr);
}
